<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>

<body><?php
$id = $_GET['id'];
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "db_shop";
 
 
 
   $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_query ("set names 'utf8'");

    
	
$sql = "delete from room where room_id='$id'";
	//require_once('page.php');
	//page($sql,'room.php',"5");//这几句是分页的句子！！
	//$sql = " SELECT * FROM room ORDER BY room_id DESC limit".$begincount.",".$rows; 
      mysql_select_db($mysql_database);
   $result=mysql_query( $sql);


    
   
	  if( $result==true){ 
	 
	  echo "<script>alert('删除成功!!'); window.location.href='orderroom.php';</script>";
	  }else{
	 echo "<script>alert('删除失败!!'); window.location.href='orderroom.php';</script>";
	}

?>
</body>
</html>
